
if exists(select name from sysobjects where name = 'sp_KhoaNichUpdateTrangThai')
	drop proc sp_KhoaNichUpdateTrangThai
go
/*
	Created by: Phuoc NH
	Created on: 13/05/2013 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_KhoaNichUpdateTrangThai.sql
*/

create proc sp_KhoaNichUpdateTrangThai
@MaSinhVien varchar(50),
@LyDo Nvarchar(max),
@nguoiKhoa int,
@TrangThai tinyint
as
begin
	insert KhoaNick(MaSinhVien, LyDo, NguoiKhoa, TrangThai) values(@MaSinhVien, @LyDo, @nguoiKhoa, @TrangThai)
end


